/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80032 (8.0.32)
 Source Host           : localhost:3306
 Source Schema         : klf_test

 Target Server Type    : MySQL
 Target Server Version : 80032 (8.0.32)
 File Encoding         : 65001

 Date: 17/04/2024 10:58:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_action_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_action_log`;
CREATE TABLE `sys_action_log` (
  `id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  `clazz` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `ipaddr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_general_ci,
  `method` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `model` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `record_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` int DEFAULT NULL,
  `oper_by` varchar(22) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK32gm4dja0jetx58r9dc2uljiu` (`oper_by`),
  CONSTRAINT `FK32gm4dja0jetx58r9dc2uljiu` FOREIGN KEY (`oper_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_action_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `create_by` varchar(22) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_by` varchar(22) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` int DEFAULT NULL,
  `value` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`),
  KEY `FK_pletj6lw7lkmi2v75qf0ptfa3` (`create_by`),
  KEY `FK_w37i6we6n67anwjwd89h5r30` (`update_by`),
  CONSTRAINT `FK_pletj6lw7lkmi2v75qf0ptfa3` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FK_w37i6we6n67anwjwd89h5r30` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`, `type`, `value`) VALUES ('3FuSNBxhQ52kSMeWAWwL9A', '2018-10-05 20:24:57', '', 1, '2022-09-02 05:03:16', '1', '1', 'MENU_TYPE', '菜单类型', 1, '1:菜单导航;2:页面列表;3:页面按钮;4:表格按钮;5:其它资源');
INSERT INTO `sys_dict` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`, `type`, `value`) VALUES ('De0zV-vnTw-IZ9kE-9vlYw', '2018-10-05 20:12:32', '', 1, '2018-10-05 20:12:32', '1', '1', 'USER_SEX', '用户性别', 1, '1:男;2:女');
INSERT INTO `sys_dict` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`, `type`, `value`) VALUES ('ickBcmy5RiSesATtLAryjA', '2018-10-05 16:03:11', '', 1, '2022-09-01 05:03:03', '1', '1', 'DATA_STATUS', '数据状态', 1, '-1:删除;1:启用;2:禁用');
INSERT INTO `sys_dict` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`, `type`, `value`) VALUES ('ijjLYjkHSPWLxdJ7HPdboQ', '2018-10-05 20:08:55', '', 1, '2022-08-31 20:36:54', '1', '1', 'DICT_TYPE', '字典类型', 1, '1:系统字典;2:业务字典');
INSERT INTO `sys_dict` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`, `type`, `value`) VALUES ('k6703KhISf6LnGdJn8DkqQ', '2018-10-05 20:28:47', '', 1, '2019-02-26 00:31:43', '1', '1', 'LOG_TYPE', '日志类型', 1, '1:业务;2:登录;3:系统');
INSERT INTO `sys_dict` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`, `type`, `value`) VALUES ('n9ecQiOXS5euxEuJqDHKvw', '2018-10-05 20:25:45', '', 1, '2019-02-26 00:34:34', '1', '1', 'SEARCH_STATUS', '搜索栏状态', 1, '1:正常;2:冻结');
INSERT INTO `sys_dict` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`, `type`, `value`) VALUES ('XwlFX2eMTQyC935HCilmjA', '2022-08-31 21:08:02', '', 1, '2022-08-31 21:08:02', '1', '1', 'ORG_ATTR', '医院属性', 2, '1:公立;2:军队;3:民营');
INSERT INTO `sys_dict` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`, `type`, `value`) VALUES ('ZrkjD21XRvKFzVTxPcw33g', '2022-08-31 21:04:46', '', 1, '2022-08-31 21:04:46', '1', '1', 'ORG_LEVEL', '医院等级', 2, '1:三级甲等;2:三级乙等;3:三级丙等');
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `md5` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mime` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `path` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sha1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `size` bigint DEFAULT NULL,
  `create_by` varchar(22) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKbdd4wds55d8pumw4osf6v687s` (`create_by`),
  CONSTRAINT `FKbdd4wds55d8pumw4osf6v687s` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `create_by` varchar(22) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_by` varchar(22) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `btn_class` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `btn_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `btn_onclick` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `level` int DEFAULT NULL,
  `perms` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pid` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pids` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sort` int DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` int DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_chmy2umajqqsxs72xupaw2bp2` (`create_by`),
  KEY `FK_qpmp4gcxex623foonm8iatf2s` (`update_by`),
  CONSTRAINT `FK_chmy2umajqqsxs72xupaw2bp2` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FK_qpmp4gcxex623foonm8iatf2s` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('-OwLbuQOQOSaMqss0ad_4w', '2019-06-27 22:49:07', NULL, 1, '2022-09-04 02:52:50', '1', '1', 'btn btn-info btn-xs', '', 'detail', NULL, 3, 'system:dict:detail', 'dQwEM9N4QRSIGHjtqJ6VOw', '[0],[oiCCCvXeR02ingDDWkzyEA],[dQwEM9N4QRSIGHjtqJ6VOw]', 4, '详情', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('0crmrv4LRd2R2NzBvaxZAw', '2019-06-26 03:35:02', NULL, 1, '2022-09-04 02:54:03', '1', '1', 'btn btn-danger btn-xs', '', 'del', NULL, 3, 'system:actionLog:delete', '3TrTMU8cQcuSU8a2DxjxIA', '[0],[oiCCCvXeR02ingDDWkzyEA],[3TrTMU8cQcuSU8a2DxjxIA]', 4, '删除', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('10D5A1XgSZeqtk6S2z59aA', '2019-06-25 22:27:39', NULL, 1, '2022-09-04 02:51:08', '1', '1', 'btn btn-danger btn-xs', '', 'del', NULL, 3, 'system:role:delete', 'YEc6bZl2TH-XexOsiVtwAA', '[0],[oiCCCvXeR02ingDDWkzyEA],[YEc6bZl2TH-XexOsiVtwAA]', 6, '删除', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('1M9-rGcRSFe8vBls0PI5Jg', '2019-06-25 21:46:56', NULL, 1, '2019-06-25 21:46:56', '1', '1', '', '', '', NULL, 2, 'system:user:index', 'oiCCCvXeR02ingDDWkzyEA', '[0],[oiCCCvXeR02ingDDWkzyEA]', 1, '用户管理', 1, '/system/user/index.shtml');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('3TrTMU8cQcuSU8a2DxjxIA', '2022-09-04 02:54:03', NULL, 1, '2022-09-04 02:54:03', '1', '1', '', '', '', NULL, 3, 'system:actionLog:list', 'hSFJ-nJ-Q8uYDh04FFTllQ', '[0],[oiCCCvXeR02ingDDWkzyEA],[hSFJ-nJ-Q8uYDh04FFTllQ]', 1, '日志列表', 2, '#');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('5iz7y-dVQmCdY7Ea5EnhdQ', '2019-06-27 22:51:17', NULL, 1, '2022-09-04 02:51:08', '1', '1', 'btn btn-info btn-xs', '', 'detail', NULL, 3, 'system:role:detail', 'YEc6bZl2TH-XexOsiVtwAA', '[0],[oiCCCvXeR02ingDDWkzyEA],[YEc6bZl2TH-XexOsiVtwAA]', 5, '详情', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('APx1auEXT2iOKtlwJqBwGQ', '2022-09-04 02:48:52', NULL, 1, '2022-09-04 02:48:52', '1', '1', '', '', '', NULL, 3, 'system:user:list', '1M9-rGcRSFe8vBls0PI5Jg', '[0],[oiCCCvXeR02ingDDWkzyEA],[1M9-rGcRSFe8vBls0PI5Jg]', 1, '用户列表', 2, '#');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('BeQB2ybKRGC3bdQffHAqdg', '2019-06-26 04:36:29', NULL, 1, '2022-09-04 02:52:50', '1', '1', 'btn btn-success btn-xs', '', 'edit', NULL, 3, 'system:dict:edit', 'dQwEM9N4QRSIGHjtqJ6VOw', '[0],[oiCCCvXeR02ingDDWkzyEA],[dQwEM9N4QRSIGHjtqJ6VOw]', 3, '编辑', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('bGvPGUNqR16AD03P4uSNmQ', '2019-06-26 03:31:03', NULL, 1, '2022-09-04 02:54:03', '1', '1', 'btn btn-warning btn-sm', 'btn-empty', '', NULL, 3, 'system:actionLog:empty', '3TrTMU8cQcuSU8a2DxjxIA', '[0],[oiCCCvXeR02ingDDWkzyEA],[3TrTMU8cQcuSU8a2DxjxIA]', 2, '清空', 3, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('dBz9BzT6Qy2loVoOL6KQMQ', '2022-09-01 20:33:01', NULL, 1, '2022-09-04 02:55:21', '1', '1', 'btn btn-danger btn-xs', '', 'delete', NULL, 2, 'xbzq:org:delete', 'yQHo_Me7QuuCm_81N5U6NA', '[0],[yQHo_Me7QuuCm_81N5U6NA]', 4, '删除', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('dQwEM9N4QRSIGHjtqJ6VOw', '2022-09-04 02:52:50', NULL, 1, '2022-09-04 02:52:50', '1', '1', '', '', '', NULL, 3, 'system:dict:list', 'kfl1px9tSh2Lknu53nXCrQ', '[0],[oiCCCvXeR02ingDDWkzyEA],[kfl1px9tSh2Lknu53nXCrQ]', 1, '数据字典列表', 2, '#');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('E2woBa-OTS2zsgXvHmuqng', '2022-09-04 03:02:16', NULL, 1, '2022-09-04 03:02:16', '1', '1', '', '', '', NULL, 3, 'system:menu:list', 'knd7ZQj7QRmLm8rubWC-2A', '[0],[oiCCCvXeR02ingDDWkzyEA],[knd7ZQj7QRmLm8rubWC-2A]', 1, '权限列表', 2, '#');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('GbC8SBjdRqeXkUuFEoQhJw', '2022-09-01 20:31:34', NULL, 1, '2022-09-04 02:55:21', '1', '1', 'btn btn-success btn-xs', '', 'edit', NULL, 2, 'xbzq:org:edit', 'yQHo_Me7QuuCm_81N5U6NA', '[0],[yQHo_Me7QuuCm_81N5U6NA]', 2, '编辑', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('HApVK8xDRdubyEZZPlTt5w', '2019-06-27 22:52:35', NULL, 1, '2022-09-02 05:22:41', '1', '1', 'btn btn-success btn-xs', '', 'edit', NULL, 3, 'system:user:edit', 'APx1auEXT2iOKtlwJqBwGQ', '[0],[oiCCCvXeR02ingDDWkzyEA],[APx1auEXT2iOKtlwJqBwGQ]', 3, '编辑', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('hSFJ-nJ-Q8uYDh04FFTllQ', '2019-06-25 21:49:26', NULL, 1, '2019-06-25 21:49:26', '1', '1', '', '', '', NULL, 2, 'system:actionLog:index', 'oiCCCvXeR02ingDDWkzyEA', '[0],[oiCCCvXeR02ingDDWkzyEA]', 4, '日志管理', 1, '/system/actionLog/index.shtml');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('Kb7UrlgfTtafQsxAYoOU5A', '2019-06-27 22:35:08', NULL, 1, '2022-09-04 02:51:08', '1', '1', 'btn btn-success btn-xs', '', 'edit', NULL, 3, 'system:role:edit', 'YEc6bZl2TH-XexOsiVtwAA', '[0],[oiCCCvXeR02ingDDWkzyEA],[YEc6bZl2TH-XexOsiVtwAA]', 4, '编辑', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('kfl1px9tSh2Lknu53nXCrQ', '2019-06-25 21:48:29', NULL, 1, '2019-06-25 21:48:29', '1', '1', '', '', '', NULL, 2, 'system:dict:index', 'oiCCCvXeR02ingDDWkzyEA', '[0],[oiCCCvXeR02ingDDWkzyEA]', 3, '数据字典', 1, '/system/dict/index.shtml');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('knd7ZQj7QRmLm8rubWC-2A', '2019-06-26 10:35:35', NULL, 1, '2019-07-01 05:23:01', '1', '1', '', '', '', NULL, 2, 'system:menu:index', 'oiCCCvXeR02ingDDWkzyEA', '[0],[oiCCCvXeR02ingDDWkzyEA]', 5, '权限管理', 1, '/system/menu/index.shtml');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('MG8BPrNwRRafeBHcug74qg', '2019-06-27 22:53:31', NULL, 1, '2022-09-02 05:22:41', '1', '1', 'btn btn-danger btn-xs', '', 'del', NULL, 3, 'system:user:delete', 'APx1auEXT2iOKtlwJqBwGQ', '[0],[oiCCCvXeR02ingDDWkzyEA],[APx1auEXT2iOKtlwJqBwGQ]', 5, '删除', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('N5b8fZkRQMq_FIFZgZy_Hg', '2022-08-31 02:15:19', NULL, 1, '2022-09-02 05:25:09', '1', '1', 'btn btn-danger btn-xs', '', 'del', NULL, 2, 'xbzq:diagnosis:delete', 'SL_DySDBSdq9WRNkbbxZyQ', '[0],[SL_DySDBSdq9WRNkbbxZyQ]', 3, '删除', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('oiCCCvXeR02ingDDWkzyEA', '2019-06-26 10:34:23', NULL, 1, '2022-08-31 00:07:07', '1', '1', '', '', '', 'fa fa-lg fa-fw fa-cog', 1, '#', '0', '[0]', 5, '系统设置', 1, '#');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('otZp-FGbR_eA1fRkcj9NxA', '2019-06-26 04:35:24', NULL, 1, '2022-09-04 02:52:50', '1', '1', 'btn btn-primary btn-sm', 'btn-add', '', NULL, 3, 'system:dict:add', 'dQwEM9N4QRSIGHjtqJ6VOw', '[0],[oiCCCvXeR02ingDDWkzyEA],[dQwEM9N4QRSIGHjtqJ6VOw]', 2, '新增', 3, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('q2Pyn-FDSSGMFLiELbsSRA', '2022-08-31 01:47:51', NULL, 1, '2022-09-02 05:25:09', '1', '1', 'btn btn-primary btn-sm', 'btn-add', '', NULL, 2, 'xbzq:diagnosis:add', 'SL_DySDBSdq9WRNkbbxZyQ', '[0],[SL_DySDBSdq9WRNkbbxZyQ]', 4, '新增', 3, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('qr-4mPULR9G3kUXNZuwUfg', '2019-06-25 21:47:31', NULL, 1, '2019-06-25 21:47:31', '1', '1', '', '', '', NULL, 2, 'system:role:index', 'oiCCCvXeR02ingDDWkzyEA', '[0],[oiCCCvXeR02ingDDWkzyEA]', 2, '角色管理', 1, '/system/role/index.shtml');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('r6O2TgSPTkO63JHcfjNlsw', '2022-09-01 05:20:15', NULL, 1, '2022-09-02 05:25:09', '1', '1', 'btn btn-success btn-xs', '', 'edit', NULL, 2, 'xbzq:diagnosis:edit', 'SL_DySDBSdq9WRNkbbxZyQ', '[0],[SL_DySDBSdq9WRNkbbxZyQ]', 2, '编辑', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('tj2aeMqyTB6Sjl5doj_E5Q', '2019-06-26 04:37:11', NULL, 1, '2022-09-04 02:52:50', '1', '1', 'btn btn-danger btn-xs', '', 'del', NULL, 3, 'system:dict:delete', 'dQwEM9N4QRSIGHjtqJ6VOw', '[0],[oiCCCvXeR02ingDDWkzyEA],[dQwEM9N4QRSIGHjtqJ6VOw]', 5, '删除', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('uL-MQjrVRjmVSDFwriLGaw', '2019-06-26 02:47:19', NULL, 1, '2022-09-02 05:22:41', '1', '1', 'btn btn-primary btn-sm', 'btn-add', '', NULL, 3, 'system:user:add', 'APx1auEXT2iOKtlwJqBwGQ', '[0],[oiCCCvXeR02ingDDWkzyEA],[APx1auEXT2iOKtlwJqBwGQ]', 2, '新增', 3, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('vrtMVgX2QRO3GrBm6FqY-g', '2019-06-25 22:25:15', NULL, 1, '2022-09-04 02:51:08', '1', '1', 'btn btn-primary btn-sm', 'btn-add', '', NULL, 3, 'system:role:add', 'YEc6bZl2TH-XexOsiVtwAA', '[0],[oiCCCvXeR02ingDDWkzyEA],[YEc6bZl2TH-XexOsiVtwAA]', 2, '新增', 3, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('Wk1Cm_JJT6qFmDb8QNqFRQ', '2022-08-30 05:45:53', NULL, 1, '2022-09-04 02:55:21', '1', '1', 'btn btn-primary btn-sm', 'btn-add', '', NULL, 2, 'xbzq:org:add', 'yQHo_Me7QuuCm_81N5U6NA', '[0],[yQHo_Me7QuuCm_81N5U6NA]', 3, '新增', 3, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('Y3Cmg_4HQ7yGOq1zydn50Q', '2019-06-25 21:50:22', NULL, 1, '2019-06-25 21:50:22', '1', '1', '', '', '', NULL, 2, 'system:druid:index', 'oiCCCvXeR02ingDDWkzyEA', '[0],[oiCCCvXeR02ingDDWkzyEA]', 6, '数据监控', 1, '/system/druid/index.shtml');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('ydHcpScmSZSIj-VhkHTZrg', '2019-06-26 03:34:07', NULL, 1, '2022-09-04 02:54:03', '1', '1', 'btn btn-info btn-xs', '', 'detail', NULL, 3, 'system:actionLog:detail', '3TrTMU8cQcuSU8a2DxjxIA', '[0],[oiCCCvXeR02ingDDWkzyEA],[3TrTMU8cQcuSU8a2DxjxIA]', 3, '详情', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('YEc6bZl2TH-XexOsiVtwAA', '2022-09-04 02:51:08', NULL, 1, '2022-09-04 02:51:08', '1', '1', '', '', '', NULL, 3, 'system:role:list', 'qr-4mPULR9G3kUXNZuwUfg', '[0],[oiCCCvXeR02ingDDWkzyEA],[qr-4mPULR9G3kUXNZuwUfg]', 1, '角色列表', 2, '#');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('zI6tgwSrQpOrmRDV3MTawg', '2019-06-26 02:48:28', NULL, 1, '2022-09-02 05:22:41', '1', '1', 'btn btn-info btn-xs', '', 'detail', NULL, 3, 'system:user:detail', 'APx1auEXT2iOKtlwJqBwGQ', '[0],[oiCCCvXeR02ingDDWkzyEA],[APx1auEXT2iOKtlwJqBwGQ]', 4, '详情', 4, '');
INSERT INTO `sys_menu` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `btn_class`, `btn_id`, `btn_onclick`, `icon`, `level`, `perms`, `pid`, `pids`, `sort`, `title`, `type`, `url`) VALUES ('Zi7bbOmjTk63ZEvhd7u9yw', '2019-06-30 21:17:04', NULL, 1, '2022-09-04 02:51:08', '1', '1', 'btn btn-warning btn-sm', 'btn-auth', '', NULL, 3, 'system:role:auth', 'YEc6bZl2TH-XexOsiVtwAA', '[0],[oiCCCvXeR02ingDDWkzyEA],[YEc6bZl2TH-XexOsiVtwAA]', 3, '授权', 3, '');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `create_by` varchar(22) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_by` varchar(22) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_9fhw9abenrp9xf4tapimn8h9u` (`update_by`),
  KEY `FK_f1tuelx21febfjdks0dgbc00r` (`create_by`),
  CONSTRAINT `FK_9fhw9abenrp9xf4tapimn8h9u` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FK_f1tuelx21febfjdks0dgbc00r` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`) VALUES ('superAdmin', '2022-08-30 17:46:54', NULL, 1, '2022-08-30 17:46:58', '1', '1', 'superAdmin', '超级管理员');
INSERT INTO `sys_role` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`) VALUES ('vi_WfeuhQfiQmuokz9rU2A', '2022-09-02 00:10:21', '', 1, '2022-09-02 00:11:01', '1', '1', 'admin', '管理员');
INSERT INTO `sys_role` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `name`, `title`) VALUES ('XjtlFShtQ1eSUPtJGvXsTQ', '2019-07-01 05:56:02', '', 1, '2022-08-31 00:41:15', '1', '1', 'user', '普通用户');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  `menu_id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`role_id`,`menu_id`),
  KEY `FKf3mud4qoc7ayew8nml4plkevo` (`menu_id`),
  CONSTRAINT `FKf3mud4qoc7ayew8nml4plkevo` FOREIGN KEY (`menu_id`) REFERENCES `sys_menu` (`id`),
  CONSTRAINT `FKkeitxsgxwayackgqllio4ohn5` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES ('vi_WfeuhQfiQmuokz9rU2A', 'dBz9BzT6Qy2loVoOL6KQMQ');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES ('vi_WfeuhQfiQmuokz9rU2A', 'GbC8SBjdRqeXkUuFEoQhJw');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES ('vi_WfeuhQfiQmuokz9rU2A', 'N5b8fZkRQMq_FIFZgZy_Hg');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES ('vi_WfeuhQfiQmuokz9rU2A', 'q2Pyn-FDSSGMFLiELbsSRA');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES ('vi_WfeuhQfiQmuokz9rU2A', 'r6O2TgSPTkO63JHcfjNlsw');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES ('vi_WfeuhQfiQmuokz9rU2A', 'Wk1Cm_JJT6qFmDb8QNqFRQ');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nickname` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `picture` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `salt` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sex` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `create_date`, `email`, `nickname`, `password`, `phone`, `picture`, `remark`, `salt`, `sex`, `status`, `update_date`, `username`) VALUES ('1', '2019-06-26 10:31:52', NULL, '左哥', '123a5155af9e2aff37506686cc627095f294087e5a645d70c5e2c182f328407b', '10086', NULL, NULL, 'J2Uq8q', '1', 1, '2022-08-29 21:07:11', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  `role_id` varchar(22) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `FKhh52n8vd4ny9ff4x9fb8v65qx` (`role_id`),
  CONSTRAINT `FKb40xxfch70f5qnyfw8yme1n1s` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKhh52n8vd4ny9ff4x9fb8v65qx` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES ('1', 'superAdmin');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
